Dataset statistics
| Number of variables | 39 |
|---|---|
| Number of observations | 7913 |
| Missing cells | 75209 |
| Missing cells (%) | 24.4% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.4 MiB |
| Average record size in memory | 312.0 B |
Variable types
| Text | 11 |
|---|---|
| DateTime | 6 |
| Categorical | 13 |
| Numeric | 6 |
| Unsupported | 3 |
Printing Date has constant value "" | Constant |
Template has constant value "" | Constant |
Printed has constant value "" | Constant |
PR Acceptance Date has constant value "" | Constant |
ReOpened is highly imbalanced (53.2%) | Imbalance |
Location Code is highly imbalanced (50.3%) | Imbalance |
Plant No_ is highly imbalanced (52.2%) | Imbalance |
PR Item Category is highly imbalanced (98.0%) | Imbalance |
PR Type is highly imbalanced (90.4%) | Imbalance |
Department has 252 (3.2%) missing values | Missing |
Intended For has 268 (3.4%) missing values | Missing |
Phase of Work has 4907 (62.0%) missing values | Missing |
Reference has 5720 (72.3%) missing values | Missing |
Work Description has 5568 (70.4%) missing values | Missing |
Batch has 6943 (87.7%) missing values | Missing |
External PR No_ has 7913 (100.0%) missing values | Missing |
Remarks has 1065 (13.5%) missing values | Missing |
Purchaser Code has 903 (11.4%) missing values | Missing |
Location Code has 7858 (99.3%) missing values | Missing |
Equipment No_ has 578 (7.3%) missing values | Missing |
Reason for Cancellation has 7876 (99.5%) missing values | Missing |
User ID has 2559 (32.3%) missing values | Missing |
MP Work Order No_ has 7913 (100.0%) missing values | Missing |
Reference MP PR No_ has 6973 (88.1%) missing values | Missing |
No_ Series has 7913 (100.0%) missing values | Missing |
timestamp has unique values | Unique |
No_ has unique values | Unique |
External PR No_ is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
MP Work Order No_ is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
No_ Series is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Dimension Set ID has 2691 (34.0%) zeros | Zeros |
PR Monitoring Status has 126 (1.6%) zeros | Zeros |
Priority has 440 (5.6%) zeros | Zeros |
Role Center Status has 3864 (48.8%) zeros | Zeros |
PR Approving Status has 7722 (97.6%) zeros | Zeros |
Reproduction
| Analysis started | 2023-10-11 01:49:34.581335 |
|---|---|
| Analysis finished | 2023-10-11 01:49:40.358419 |
| Duration | 5.78 seconds |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
timestamp
Text
UNIQUE 
| Distinct | 7913 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 16 |
| Min length | 16 |
Characters and Unicode
| Total characters | 126608 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 7913 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 000000000FD66B8C |
|---|---|
| 2nd row | 000000000FD66B8D |
| 3rd row | 000000000FD66B8E |
| 4th row | 000000000FD66B8F |
| 5th row | 000000000FD66B90 |
| Value | Count | Frequency (%) |
| 000000000fd66b8c | 1 | < 0.1% |
| 000000000fd66b8e | 1 | < 0.1% |
| 000000000fd66b90 | 1 | < 0.1% |
| 000000000fd66b91 | 1 | < 0.1% |
| 000000000fd66b92 | 1 | < 0.1% |
| 000000000fd66b93 | 1 | < 0.1% |
| 000000000fd66b94 | 1 | < 0.1% |
| 000000000fd66b95 | 1 | < 0.1% |
| 000000000fd66b96 | 1 | < 0.1% |
| 000000000fd66b97 | 1 | < 0.1% |
| Other values (7903) | 7903 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 72774 | |
| 6 | 10087 | 8.0% |
| F | 9027 | 7.1% |
| D | 9014 | 7.1% |
| 7 | 5598 | 4.4% |
| 8 | 3837 | 3.0% |
| 1 | 2189 | 1.7% |
| C | 1738 | 1.4% |
| E | 1633 | 1.3% |
| 9 | 1618 | 1.3% |
| Other values (6) | 9093 | 7.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 102233 | |
| Uppercase Letter | 24375 | 19.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 72774 | |
| 6 | 10087 | 9.9% |
| 7 | 5598 | 5.5% |
| 8 | 3837 | 3.8% |
| 1 | 2189 | 2.1% |
| 9 | 1618 | 1.6% |
| 4 | 1597 | 1.6% |
| 2 | 1574 | 1.5% |
| 3 | 1566 | 1.5% |
| 5 | 1393 | 1.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 9027 | |
| D | 9014 | |
| C | 1738 | 7.1% |
| E | 1633 | 6.7% |
| B | 1609 | 6.6% |
| A | 1354 | 5.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 102233 | |
| Latin | 24375 | 19.3% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 72774 | |
| 6 | 10087 | 9.9% |
| 7 | 5598 | 5.5% |
| 8 | 3837 | 3.8% |
| 1 | 2189 | 2.1% |
| 9 | 1618 | 1.6% |
| 4 | 1597 | 1.6% |
| 2 | 1574 | 1.5% |
| 3 | 1566 | 1.5% |
| 5 | 1393 | 1.4% |
Latin
| Value | Count | Frequency (%) |
| F | 9027 | |
| D | 9014 | |
| C | 1738 | 7.1% |
| E | 1633 | 6.7% |
| B | 1609 | 6.6% |
| A | 1354 | 5.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 126608 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 72774 | |
| 6 | 10087 | 8.0% |
| F | 9027 | 7.1% |
| D | 9014 | 7.1% |
| 7 | 5598 | 4.4% |
| 8 | 3837 | 3.0% |
| 1 | 2189 | 1.7% |
| C | 1738 | 1.4% |
| E | 1633 | 1.3% |
| 9 | 1618 | 1.3% |
| Other values (6) | 9093 | 7.2% |
No_
Text
UNIQUE 
| Distinct | 7913 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
Length
| Max length | 15 |
|---|---|
| Median length | 10 |
| Mean length | 10.152028 |
| Min length | 8 |
Characters and Unicode
| Total characters | 80333 |
|---|---|
| Distinct characters | 30 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 7913 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | BRPR-00003 |
|---|---|
| 2nd row | BRPR-00004 |
| 3rd row | BRPR-00005 |
| 4th row | BRPR-00006 |
| 5th row | BRPR-00007 |
| Value | Count | Frequency (%) |
| brpr-00003 | 1 | < 0.1% |
| brpr-00005 | 1 | < 0.1% |
| brpr-00007 | 1 | < 0.1% |
| brpr-00008 | 1 | < 0.1% |
| brpr-00009 | 1 | < 0.1% |
| brpr-00010 | 1 | < 0.1% |
| brpr-00011 | 1 | < 0.1% |
| brpr-00012 | 1 | < 0.1% |
| brpr-00013 | 1 | < 0.1% |
| brpr-00014 | 1 | < 0.1% |
| Other values (7903) | 7903 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 16998 | |
| P | 9237 | |
| R | 8745 | |
| - | 6416 | 8.0% |
| 1 | 3977 | 5.0% |
| E | 3791 | 4.7% |
| 2 | 2804 | 3.5% |
| M | 2767 | 3.4% |
| 3 | 2553 | 3.2% |
| C | 2427 | 3.0% |
| Other values (20) | 20618 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 37833 | |
| Uppercase Letter | 36084 | |
| Dash Punctuation | 6416 | 8.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 9237 | |
| R | 8745 | |
| E | 3791 | |
| M | 2767 | 7.7% |
| C | 2427 | 6.7% |
| S | 2074 | 5.7% |
| L | 1754 | 4.9% |
| G | 1251 | 3.5% |
| N | 846 | 2.3% |
| O | 605 | 1.7% |
| Other values (9) | 2587 | 7.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 16998 | |
| 1 | 3977 | 10.5% |
| 2 | 2804 | 7.4% |
| 3 | 2553 | 6.7% |
| 4 | 2338 | 6.2% |
| 5 | 2113 | 5.6% |
| 6 | 1952 | 5.2% |
| 7 | 1779 | 4.7% |
| 8 | 1698 | 4.5% |
| 9 | 1621 | 4.3% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 6416 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 44249 | |
| Latin | 36084 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 9237 | |
| R | 8745 | |
| E | 3791 | |
| M | 2767 | 7.7% |
| C | 2427 | 6.7% |
| S | 2074 | 5.7% |
| L | 1754 | 4.9% |
| G | 1251 | 3.5% |
| N | 846 | 2.3% |
| O | 605 | 1.7% |
| Other values (9) | 2587 | 7.2% |
Common
| Value | Count | Frequency (%) |
| 0 | 16998 | |
| - | 6416 | 14.5% |
| 1 | 3977 | 9.0% |
| 2 | 2804 | 6.3% |
| 3 | 2553 | 5.8% |
| 4 | 2338 | 5.3% |
| 5 | 2113 | 4.8% |
| 6 | 1952 | 4.4% |
| 7 | 1779 | 4.0% |
| 8 | 1698 | 3.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 80333 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 16998 | |
| P | 9237 | |
| R | 8745 | |
| - | 6416 | 8.0% |
| 1 | 3977 | 5.0% |
| E | 3791 | 4.7% |
| 2 | 2804 | 3.5% |
| M | 2767 | 3.4% |
| 3 | 2553 | 3.2% |
| C | 2427 | 3.0% |
| Other values (20) | 20618 |
PR Date
Date
| Distinct | 1898 |
|---|---|
| Distinct (%) | 24.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
| Minimum | 2013-01-02 00:00:00 |
|---|---|
| Maximum | 2021-07-11 00:00:00 |
Printing Date
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
| -53688 |
|---|
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 47478 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | -53688 |
|---|---|
| 2nd row | -53688 |
| 3rd row | -53688 |
| 4th row | -53688 |
| 5th row | -53688 |
Common Values
| Value | Count | Frequency (%) |
| -53688 | 7913 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 53688 | 7913 |
Most occurring characters
| Value | Count | Frequency (%) |
| 8 | 15826 | |
| - | 7913 | |
| 5 | 7913 | |
| 3 | 7913 | |
| 6 | 7913 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 39565 | |
| Dash Punctuation | 7913 | 16.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 8 | 15826 | |
| 5 | 7913 | |
| 3 | 7913 | |
| 6 | 7913 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 7913 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 47478 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 8 | 15826 | |
| - | 7913 | |
| 5 | 7913 | |
| 3 | 7913 | |
| 6 | 7913 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 47478 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 8 | 15826 | |
| - | 7913 | |
| 5 | 7913 | |
| 3 | 7913 | |
| 6 | 7913 |
Department
Real number (ℝ)
MISSING 
| Distinct | 52 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 252 |
| Missing (%) | 3.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 690.14463 |
| Minimum | 100 |
|---|---|
| Maximum | 1010 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 61.9 KiB |
Quantile statistics
| Minimum | 100 |
|---|---|
| 5-th percentile | 120 |
| Q1 | 420 |
| median | 833 |
| Q3 | 834 |
| 95-th percentile | 843 |
| Maximum | 1010 |
| Range | 910 |
| Interquartile range (IQR) | 414 |
Descriptive statistics
| Standard deviation | 258.05338 |
|---|---|
| Coefficient of variation (CV) | 0.37391204 |
| Kurtosis | 0.037206738 |
| Mean | 690.14463 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -1.2730845 |
| Sum | 5287198 |
| Variance | 66591.548 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 833 | 2472 | |
| 834 | 935 | 11.8% |
| 420 | 527 | 6.7% |
| 835 | 519 | 6.6% |
| 100 | 369 | 4.7% |
| 843 | 350 | 4.4% |
| 822 | 336 | 4.2% |
| 330 | 279 | 3.5% |
| 813 | 243 | 3.1% |
| 1010 | 188 | 2.4% |
| Other values (42) | 1443 | |
| (Missing) | 252 | 3.2% |
| Value | Count | Frequency (%) |
| 100 | 369 | |
| 110 | 1 | < 0.1% |
| 120 | 146 | 1.8% |
| 131 | 2 | < 0.1% |
| 132 | 1 | < 0.1% |
| 140 | 102 | 1.3% |
| 150 | 49 | 0.6% |
| 151 | 4 | 0.1% |
| 152 | 2 | < 0.1% |
| 160 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1010 | 188 | |
| 1000 | 5 | 0.1% |
| 905 | 3 | < 0.1% |
| 848 | 10 | 0.1% |
| 847 | 92 | 1.2% |
| 846 | 4 | 0.1% |
| 845 | 13 | 0.2% |
| 844 | 3 | < 0.1% |
| 843 | 350 | |
| 842 | 10 | 0.1% |
Intended For
Text
MISSING 
| Distinct | 4264 |
|---|---|
| Distinct (%) | 55.8% |
| Missing | 268 |
| Missing (%) | 3.4% |
| Memory size | 61.9 KiB |
Length
| Max length | 85 |
|---|---|
| Median length | 54 |
| Mean length | 21.297842 |
| Min length | 2 |
Characters and Unicode
| Total characters | 162822 |
|---|---|
| Distinct characters | 75 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3347 ? |
|---|---|
| Unique (%) | 43.8% |
Sample
| 1st row | 2X150MW POWER PLANT |
|---|---|
| 2nd row | 2X150MW POWER PLANT |
| 3rd row | 2X150MW POWER PLANT |
| 4th row | 2X150MW POWER PLANT |
| 5th row | 2X150MW POWER PLANT |
| Value | Count | Frequency (%) |
| plant | 659 | 2.7% |
| slpgc | 632 | 2.6% |
| power | 559 | 2.3% |
| unit | 523 | 2.1% |
| maintenance | 447 | 1.8% |
| 419 | 1.7% | |
| mechanical | 340 | 1.4% |
| boiler | 308 | 1.2% |
| mw | 303 | 1.2% |
| system | 302 | 1.2% |
| Other values (2366) | 20191 |
Most occurring characters
| Value | Count | Frequency (%) |
| 17068 | 10.5% | |
| e | 10773 | 6.6% |
| n | 8081 | 5.0% |
| a | 7751 | 4.8% |
| i | 7203 | 4.4% |
| t | 6961 | 4.3% |
| r | 6691 | 4.1% |
| o | 5945 | 3.7% |
| l | 4901 | 3.0% |
| E | 4678 | 2.9% |
| Other values (65) | 82770 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 80955 | |
| Uppercase Letter | 58577 | |
| Space Separator | 17068 | 10.5% |
| Decimal Number | 4356 | 2.7% |
| Other Punctuation | 1140 | 0.7% |
| Dash Punctuation | 576 | 0.4% |
| Open Punctuation | 76 | < 0.1% |
| Close Punctuation | 73 | < 0.1% |
| Math Symbol | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 10773 | |
| n | 8081 | |
| a | 7751 | |
| i | 7203 | |
| t | 6961 | |
| r | 6691 | |
| o | 5945 | 7.3% |
| l | 4901 | 6.1% |
| s | 3480 | 4.3% |
| c | 3380 | 4.2% |
| Other values (16) | 15789 |
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 4678 | 8.0% |
| S | 4544 | 7.8% |
| P | 4465 | 7.6% |
| A | 4218 | 7.2% |
| C | 4133 | 7.1% |
| T | 3968 | 6.8% |
| R | 3605 | 6.2% |
| M | 3486 | 6.0% |
| O | 3225 | 5.5% |
| L | 3184 | 5.4% |
| Other values (16) | 19071 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 949 | |
| 1 | 731 | |
| 5 | 697 | |
| 0 | 627 | |
| 3 | 599 | |
| 4 | 548 | |
| 6 | 103 | 2.4% |
| 9 | 45 | 1.0% |
| 8 | 30 | 0.7% |
| 7 | 27 | 0.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 428 | |
| . | 323 | |
| / | 260 | |
| , | 46 | 4.0% |
| # | 43 | 3.8% |
| ' | 37 | 3.2% |
| % | 2 | 0.2% |
| : | 1 | 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 17068 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 576 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 76 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 73 |
Math Symbol
| Value | Count | Frequency (%) |
| = | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 139532 | |
| Common | 23290 | 14.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 10773 | 7.7% |
| n | 8081 | 5.8% |
| a | 7751 | 5.6% |
| i | 7203 | 5.2% |
| t | 6961 | 5.0% |
| r | 6691 | 4.8% |
| o | 5945 | 4.3% |
| l | 4901 | 3.5% |
| E | 4678 | 3.4% |
| S | 4544 | 3.3% |
| Other values (42) | 72004 |
Common
| Value | Count | Frequency (%) |
| 17068 | ||
| 2 | 949 | 4.1% |
| 1 | 731 | 3.1% |
| 5 | 697 | 3.0% |
| 0 | 627 | 2.7% |
| 3 | 599 | 2.6% |
| - | 576 | 2.5% |
| 4 | 548 | 2.4% |
| & | 428 | 1.8% |
| . | 323 | 1.4% |
| Other values (13) | 744 | 3.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 162822 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 17068 | 10.5% | |
| e | 10773 | 6.6% |
| n | 8081 | 5.0% |
| a | 7751 | 4.8% |
| i | 7203 | 4.4% |
| t | 6961 | 4.3% |
| r | 6691 | 4.1% |
| o | 5945 | 3.7% |
| l | 4901 | 3.0% |
| E | 4678 | 2.9% |
| Other values (65) | 82770 |
Phase of Work
Text
MISSING 
| Distinct | 1376 |
|---|---|
| Distinct (%) | 45.8% |
| Missing | 4907 |
| Missing (%) | 62.0% |
| Memory size | 61.9 KiB |
Length
| Max length | 120 |
|---|---|
| Median length | 47 |
| Mean length | 20.337991 |
| Min length | 1 |
Characters and Unicode
| Total characters | 61136 |
|---|---|
| Distinct characters | 75 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1087 ? |
|---|---|
| Unique (%) | 36.2% |
Sample
| 1st row | Regeneration for resin of mixed bed exchangers |
|---|---|
| 2nd row | Regeneration for resin of mixed bed exchangers |
| 3rd row | Transferring Liquid Chemicals |
| 4th row | Regeneration for resin of mixed bed exchangers |
| 5th row | Regeneration for resin of mixed bed exchangers |
| Value | Count | Frequency (%) |
| of | 505 | 5.9% |
| maintenance | 331 | 3.9% |
| spare | 313 | 3.7% |
| 274 | 3.2% | |
| for | 179 | 2.1% |
| supply | 173 | 2.0% |
| analysis | 156 | 1.8% |
| calibration | 151 | 1.8% |
| parts | 138 | 1.6% |
| and | 137 | 1.6% |
| Other values (1337) | 6165 |
Most occurring characters
| Value | Count | Frequency (%) |
| 5536 | 9.1% | |
| n | 3666 | 6.0% |
| e | 3512 | 5.7% |
| a | 3178 | 5.2% |
| i | 2815 | 4.6% |
| t | 2484 | 4.1% |
| o | 2352 | 3.8% |
| A | 2232 | 3.7% |
| S | 2137 | 3.5% |
| r | 2105 | 3.4% |
| Other values (65) | 31119 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 30834 | |
| Uppercase Letter | 21142 | |
| Space Separator | 5536 | 9.1% |
| Decimal Number | 2169 | 3.5% |
| Other Punctuation | 631 | 1.0% |
| Dash Punctuation | 601 | 1.0% |
| Close Punctuation | 112 | 0.2% |
| Open Punctuation | 111 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 3666 | |
| e | 3512 | |
| a | 3178 | |
| i | 2815 | |
| t | 2484 | 8.1% |
| o | 2352 | 7.6% |
| r | 2105 | 6.8% |
| l | 1618 | 5.2% |
| s | 1365 | 4.4% |
| c | 1215 | 3.9% |
| Other values (16) | 6524 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 2232 | 10.6% |
| S | 2137 | 10.1% |
| E | 1717 | 8.1% |
| R | 1534 | 7.3% |
| P | 1484 | 7.0% |
| N | 1312 | 6.2% |
| T | 1296 | 6.1% |
| C | 1269 | 6.0% |
| O | 1251 | 5.9% |
| M | 1236 | 5.8% |
| Other values (16) | 5674 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 658 | |
| 2 | 332 | |
| 3 | 279 | |
| 1 | 275 | |
| 4 | 253 | 11.7% |
| 5 | 178 | 8.2% |
| 6 | 68 | 3.1% |
| 9 | 65 | 3.0% |
| 8 | 35 | 1.6% |
| 7 | 26 | 1.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 241 | |
| , | 189 | |
| & | 114 | |
| . | 69 | 10.9% |
| ' | 10 | 1.6% |
| # | 3 | 0.5% |
| ; | 2 | 0.3% |
| @ | 2 | 0.3% |
| : | 1 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 5536 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 601 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 112 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 111 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 51976 | |
| Common | 9160 | 15.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 3666 | 7.1% |
| e | 3512 | 6.8% |
| a | 3178 | 6.1% |
| i | 2815 | 5.4% |
| t | 2484 | 4.8% |
| o | 2352 | 4.5% |
| A | 2232 | 4.3% |
| S | 2137 | 4.1% |
| r | 2105 | 4.0% |
| E | 1717 | 3.3% |
| Other values (42) | 25778 |
Common
| Value | Count | Frequency (%) |
| 5536 | ||
| 0 | 658 | 7.2% |
| - | 601 | 6.6% |
| 2 | 332 | 3.6% |
| 3 | 279 | 3.0% |
| 1 | 275 | 3.0% |
| 4 | 253 | 2.8% |
| / | 241 | 2.6% |
| , | 189 | 2.1% |
| 5 | 178 | 1.9% |
| Other values (13) | 618 | 6.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 61136 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 5536 | 9.1% | |
| n | 3666 | 6.0% |
| e | 3512 | 5.7% |
| a | 3178 | 5.2% |
| i | 2815 | 4.6% |
| t | 2484 | 4.1% |
| o | 2352 | 3.8% |
| A | 2232 | 3.7% |
| S | 2137 | 3.5% |
| r | 2105 | 3.4% |
| Other values (65) | 31119 |
Reference
Text
MISSING 
| Distinct | 1369 |
|---|---|
| Distinct (%) | 62.4% |
| Missing | 5720 |
| Missing (%) | 72.3% |
| Memory size | 61.9 KiB |
Length
| Max length | 50 |
|---|---|
| Median length | 45 |
| Mean length | 18.008664 |
| Min length | 1 |
Characters and Unicode
| Total characters | 39493 |
|---|---|
| Distinct characters | 71 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1287 ? |
|---|---|
| Unique (%) | 58.7% |
Sample
| 1st row | BILLING INVOICE |
|---|---|
| 2nd row | ATTACHED BROKER SOA |
| 3rd row | ATTACHED BROKER SOA |
| 4th row | ATTACHED BILLING STATEMENT |
| 5th row | ATTACHED BROKER'S BILLING |
| Value | Count | Frequency (%) |
| attached | 462 | 10.7% |
| form | 254 | 5.9% |
| request | 252 | 5.9% |
| payment | 251 | 5.8% |
| recommended | 231 | 5.4% |
| mainpac | 226 | 5.3% |
| billing | 197 | 4.6% |
| item | 193 | 4.5% |
| invoice | 182 | 4.2% |
| kms | 70 | 1.6% |
| Other values (1448) | 1984 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 3093 | 7.8% |
| 0 | 2752 | 7.0% |
| e | 2392 | 6.1% |
| 2113 | 5.4% | |
| 1 | 1630 | 4.1% |
| t | 1570 | 4.0% |
| M | 1515 | 3.8% |
| 2 | 1330 | 3.4% |
| m | 1289 | 3.3% |
| P | 1215 | 3.1% |
| Other values (61) | 20594 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 12969 | |
| Uppercase Letter | 12336 | |
| Decimal Number | 8778 | |
| Dash Punctuation | 3093 | 7.8% |
| Space Separator | 2113 | 5.4% |
| Other Punctuation | 191 | 0.5% |
| Open Punctuation | 6 | < 0.1% |
| Close Punctuation | 6 | < 0.1% |
| Math Symbol | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 2392 | |
| t | 1570 | |
| m | 1289 | |
| a | 1135 | |
| n | 1028 | |
| c | 882 | 6.8% |
| d | 837 | 6.5% |
| o | 616 | 4.7% |
| i | 533 | 4.1% |
| h | 404 | 3.1% |
| Other values (15) | 2283 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 1515 | |
| P | 1215 | |
| L | 1089 | |
| I | 1040 | |
| D | 1009 | |
| S | 998 | |
| E | 938 | 7.6% |
| C | 766 | 6.2% |
| R | 727 | 5.9% |
| A | 661 | 5.4% |
| Other values (14) | 2378 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 2752 | |
| 1 | 1630 | |
| 2 | 1330 | |
| 8 | 572 | 6.5% |
| 9 | 568 | 6.5% |
| 5 | 425 | 4.8% |
| 3 | 421 | 4.8% |
| 4 | 390 | 4.4% |
| 7 | 368 | 4.2% |
| 6 | 322 | 3.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 121 | |
| / | 22 | 11.5% |
| . | 21 | 11.0% |
| : | 10 | 5.2% |
| ' | 9 | 4.7% |
| # | 6 | 3.1% |
| & | 2 | 1.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3093 |
Space Separator
| Value | Count | Frequency (%) |
| 2113 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 6 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 6 |
Math Symbol
| Value | Count | Frequency (%) |
| | | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 25305 | |
| Common | 14188 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 2392 | 9.5% |
| t | 1570 | 6.2% |
| M | 1515 | 6.0% |
| m | 1289 | 5.1% |
| P | 1215 | 4.8% |
| a | 1135 | 4.5% |
| L | 1089 | 4.3% |
| I | 1040 | 4.1% |
| n | 1028 | 4.1% |
| D | 1009 | 4.0% |
| Other values (39) | 12023 |
Common
| Value | Count | Frequency (%) |
| - | 3093 | |
| 0 | 2752 | |
| 2113 | ||
| 1 | 1630 | |
| 2 | 1330 | |
| 8 | 572 | 4.0% |
| 9 | 568 | 4.0% |
| 5 | 425 | 3.0% |
| 3 | 421 | 3.0% |
| 4 | 390 | 2.7% |
| Other values (12) | 894 | 6.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 39493 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 3093 | 7.8% |
| 0 | 2752 | 7.0% |
| e | 2392 | 6.1% |
| 2113 | 5.4% | |
| 1 | 1630 | 4.1% |
| t | 1570 | 4.0% |
| M | 1515 | 3.8% |
| 2 | 1330 | 3.4% |
| m | 1289 | 3.3% |
| P | 1215 | 3.1% |
| Other values (61) | 20594 |
Work Description
Text
MISSING 
| Distinct | 1831 |
|---|---|
| Distinct (%) | 78.1% |
| Missing | 5568 |
| Missing (%) | 70.4% |
| Memory size | 61.9 KiB |
Length
| Max length | 124 |
|---|---|
| Median length | 45 |
| Mean length | 28.856716 |
| Min length | 1 |
Characters and Unicode
| Total characters | 67669 |
|---|---|
| Distinct characters | 74 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1587 ? |
|---|---|
| Unique (%) | 67.7% |
Sample
| 1st row | ATTACHED BILLING INVOICE |
|---|---|
| 2nd row | ATTACHED BILLING INVOICE |
| 3rd row | ATTACHED BILLING INVOICE |
| 4th row | ATTACHED BILLING INVOICE |
| 5th row | ATTACHED BILLING INVOICE |
| Value | Count | Frequency (%) |
| of | 1017 | 10.1% |
| for | 259 | 2.6% |
| and | 246 | 2.5% |
| purchase | 233 | 2.3% |
| calibration | 185 | 1.8% |
| supply | 176 | 1.8% |
| 162 | 1.6% | |
| water | 162 | 1.6% |
| replacement | 158 | 1.6% |
| installation | 141 | 1.4% |
| Other values (1775) | 7282 |
Most occurring characters
| Value | Count | Frequency (%) |
| 7698 | 11.4% | |
| e | 4440 | 6.6% |
| a | 3633 | 5.4% |
| o | 3320 | 4.9% |
| n | 3290 | 4.9% |
| i | 3280 | 4.8% |
| r | 2917 | 4.3% |
| t | 2849 | 4.2% |
| l | 2342 | 3.5% |
| s | 1999 | 3.0% |
| Other values (64) | 31901 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 38290 | |
| Uppercase Letter | 19073 | |
| Space Separator | 7698 | 11.4% |
| Decimal Number | 1657 | 2.4% |
| Other Punctuation | 527 | 0.8% |
| Dash Punctuation | 233 | 0.3% |
| Open Punctuation | 96 | 0.1% |
| Close Punctuation | 95 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 4440 | |
| a | 3633 | |
| o | 3320 | 8.7% |
| n | 3290 | 8.6% |
| i | 3280 | 8.6% |
| r | 2917 | 7.6% |
| t | 2849 | 7.4% |
| l | 2342 | 6.1% |
| s | 1999 | 5.2% |
| c | 1500 | 3.9% |
| Other values (16) | 8720 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 1562 | 8.2% |
| T | 1549 | 8.1% |
| R | 1511 | 7.9% |
| E | 1481 | 7.8% |
| I | 1411 | 7.4% |
| S | 1309 | 6.9% |
| C | 1166 | 6.1% |
| P | 1158 | 6.1% |
| O | 1072 | 5.6% |
| N | 971 | 5.1% |
| Other values (16) | 5883 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 547 | |
| 3 | 215 | 13.0% |
| 2 | 198 | 11.9% |
| 5 | 186 | 11.2% |
| 1 | 159 | 9.6% |
| 4 | 157 | 9.5% |
| 6 | 70 | 4.2% |
| 9 | 55 | 3.3% |
| 8 | 43 | 2.6% |
| 7 | 27 | 1.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 223 | |
| & | 137 | |
| / | 87 | 16.5% |
| . | 68 | 12.9% |
| # | 6 | 1.1% |
| ' | 3 | 0.6% |
| ; | 2 | 0.4% |
| : | 1 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 7698 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 233 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 96 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 95 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 57363 | |
| Common | 10306 | 15.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 4440 | 7.7% |
| a | 3633 | 6.3% |
| o | 3320 | 5.8% |
| n | 3290 | 5.7% |
| i | 3280 | 5.7% |
| r | 2917 | 5.1% |
| t | 2849 | 5.0% |
| l | 2342 | 4.1% |
| s | 1999 | 3.5% |
| A | 1562 | 2.7% |
| Other values (42) | 27731 |
Common
| Value | Count | Frequency (%) |
| 7698 | ||
| 0 | 547 | 5.3% |
| - | 233 | 2.3% |
| , | 223 | 2.2% |
| 3 | 215 | 2.1% |
| 2 | 198 | 1.9% |
| 5 | 186 | 1.8% |
| 1 | 159 | 1.5% |
| 4 | 157 | 1.5% |
| & | 137 | 1.3% |
| Other values (12) | 553 | 5.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 67669 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 7698 | 11.4% | |
| e | 4440 | 6.6% |
| a | 3633 | 5.4% |
| o | 3320 | 4.9% |
| n | 3290 | 4.9% |
| i | 3280 | 4.8% |
| r | 2917 | 4.3% |
| t | 2849 | 4.2% |
| l | 2342 | 3.5% |
| s | 1999 | 3.0% |
| Other values (64) | 31901 |
Date Needed
Date
| Distinct | 1974 |
|---|---|
| Distinct (%) | 24.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
| Minimum | 1753-01-01 00:00:00 |
|---|---|
| Maximum | 2025-11-23 00:00:00 |
Batch
Text
MISSING 
| Distinct | 970 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 6943 |
| Missing (%) | 87.7% |
| Memory size | 61.9 KiB |
Length
| Max length | 15 |
|---|---|
| Median length | 10 |
| Mean length | 10.010309 |
| Min length | 8 |
Characters and Unicode
| Total characters | 9710 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 970 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | BRPR-00002 |
|---|---|
| 2nd row | CHEPR-0040 |
| 3rd row | CHEPR-0315 |
| 4th row | CRPR-0004 |
| 5th row | ELEPR-0041 |
| Value | Count | Frequency (%) |
| smppr00637 | 1 | 0.1% |
| smppr00029 | 1 | 0.1% |
| slpr-0000000366 | 1 | 0.1% |
| incpr-0100 | 1 | 0.1% |
| chepr-0040 | 1 | 0.1% |
| chepr-0315 | 1 | 0.1% |
| crpr-0004 | 1 | 0.1% |
| elepr-0041 | 1 | 0.1% |
| elepr-0054 | 1 | 0.1% |
| elepr-0410 | 1 | 0.1% |
| Other values (960) | 960 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 2245 | |
| P | 1913 | |
| R | 974 | |
| S | 945 | |
| M | 945 | |
| 1 | 309 | 3.2% |
| 3 | 303 | 3.1% |
| 2 | 302 | 3.1% |
| 4 | 294 | 3.0% |
| 5 | 293 | 3.0% |
| Other values (17) | 1187 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 4841 | |
| Uppercase Letter | 4840 | |
| Dash Punctuation | 29 | 0.3% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 1913 | |
| R | 974 | |
| S | 945 | |
| M | 945 | |
| E | 17 | 0.4% |
| C | 11 | 0.2% |
| L | 8 | 0.2% |
| N | 7 | 0.1% |
| G | 5 | 0.1% |
| I | 3 | 0.1% |
| Other values (6) | 12 | 0.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 2245 | |
| 1 | 309 | 6.4% |
| 3 | 303 | 6.3% |
| 2 | 302 | 6.2% |
| 4 | 294 | 6.1% |
| 5 | 293 | 6.1% |
| 6 | 291 | 6.0% |
| 8 | 288 | 5.9% |
| 7 | 286 | 5.9% |
| 9 | 230 | 4.8% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 29 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 4870 | |
| Latin | 4840 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| P | 1913 | |
| R | 974 | |
| S | 945 | |
| M | 945 | |
| E | 17 | 0.4% |
| C | 11 | 0.2% |
| L | 8 | 0.2% |
| N | 7 | 0.1% |
| G | 5 | 0.1% |
| I | 3 | 0.1% |
| Other values (6) | 12 | 0.2% |
Common
| Value | Count | Frequency (%) |
| 0 | 2245 | |
| 1 | 309 | 6.3% |
| 3 | 303 | 6.2% |
| 2 | 302 | 6.2% |
| 4 | 294 | 6.0% |
| 5 | 293 | 6.0% |
| 6 | 291 | 6.0% |
| 8 | 288 | 5.9% |
| 7 | 286 | 5.9% |
| 9 | 230 | 4.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 9710 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 2245 | |
| P | 1913 | |
| R | 974 | |
| S | 945 | |
| M | 945 | |
| 1 | 309 | 3.2% |
| 3 | 303 | 3.1% |
| 2 | 302 | 3.1% |
| 4 | 294 | 3.0% |
| 5 | 293 | 3.0% |
| Other values (17) | 1187 |
Template
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
| REQ. |
|---|
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 31652 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | REQ. |
|---|---|
| 2nd row | REQ. |
| 3rd row | REQ. |
| 4th row | REQ. |
| 5th row | REQ. |
Common Values
| Value | Count | Frequency (%) |
| REQ. | 7913 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| req | 7913 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 7913 | |
| E | 7913 | |
| Q | 7913 | |
| . | 7913 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 23739 | |
| Other Punctuation | 7913 | 25.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 7913 | |
| E | 7913 | |
| Q | 7913 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 7913 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 23739 | |
| Common | 7913 | 25.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 7913 | |
| E | 7913 | |
| Q | 7913 |
Common
| Value | Count | Frequency (%) |
| . | 7913 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 31652 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 7913 | |
| E | 7913 | |
| Q | 7913 | |
| . | 7913 |
External PR No_
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 7913 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 61.9 KiB |
Status
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 7913 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 6827 | |
| 0 | 1086 | 13.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 6827 | |
| 0 | 1086 | 13.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 6827 | |
| 0 | 1086 | 13.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 7913 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 6827 | |
| 0 | 1086 | 13.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 7913 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 6827 | |
| 0 | 1086 | 13.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7913 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 6827 | |
| 0 | 1086 | 13.7% |
ReOpened
Categorical
IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 7913 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 7124 | |
| 0 | 789 | 10.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 7124 | |
| 0 | 789 | 10.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 7124 | |
| 0 | 789 | 10.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 7913 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 7124 | |
| 0 | 789 | 10.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 7913 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 7124 | |
| 0 | 789 | 10.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7913 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 7124 | |
| 0 | 789 | 10.0% |
Release Date
Date
| Distinct | 1218 |
|---|---|
| Distinct (%) | 15.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
| Minimum | 1753-01-01 00:00:00 |
|---|---|
| Maximum | 2021-07-12 00:00:00 |
Remarks
Text
MISSING 
| Distinct | 6762 |
|---|---|
| Distinct (%) | 98.7% |
| Missing | 1065 |
| Missing (%) | 13.5% |
| Memory size | 61.9 KiB |
Length
| Max length | 150 |
|---|---|
| Median length | 129 |
| Mean length | 49.566297 |
| Min length | 3 |
Characters and Unicode
| Total characters | 339430 |
|---|---|
| Distinct characters | 83 |
| Distinct categories | 10 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 6730 ? |
|---|---|
| Unique (%) | 98.3% |
Sample
| 1st row | SLBPO-000028 OCEAN STAR FREIGHT EXPRESS |
|---|---|
| 2nd row | SLBPO-000002 AMERICAN FREIGHT FORWARDERS, INC. |
| 3rd row | SLBPO-000003 CARGO PLUS FREIGHT EXPRESS |
| 4th row | SLBPO-000020 GCLPI-GATEWAY CONTAINER LINE PHILS. INC. |
| 5th row | SLBPO-000019 CARGO PLUS FREIGHT EXPRESS |
| Value | Count | Frequency (%) |
| 2130 | 5.2% | |
| inc | 1782 | 4.3% |
| services | 603 | 1.5% |
| industrial | 543 | 1.3% |
| for | 536 | 1.3% |
| ltd | 497 | 1.2% |
| te | 476 | 1.2% |
| rcvd | 462 | 1.1% |
| ind'l | 446 | 1.1% |
| corporation | 432 | 1.1% |
| Other values (11525) | 33132 |
Most occurring characters
| Value | Count | Frequency (%) |
| 34300 | 10.1% | |
| 0 | 27036 | 8.0% |
| S | 17618 | 5.2% |
| O | 16604 | 4.9% |
| L | 14511 | 4.3% |
| E | 13838 | 4.1% |
| - | 12279 | 3.6% |
| R | 11539 | 3.4% |
| P | 11376 | 3.4% |
| I | 10939 | 3.2% |
| Other values (73) | 169390 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 166161 | |
| Decimal Number | 64155 | 18.9% |
| Lowercase Letter | 49170 | 14.5% |
| Space Separator | 34300 | 10.1% |
| Dash Punctuation | 12281 | 3.6% |
| Other Punctuation | 12173 | 3.6% |
| Open Punctuation | 594 | 0.2% |
| Close Punctuation | 593 | 0.2% |
| Math Symbol | 2 | < 0.1% |
| Modifier Symbol | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 17618 | |
| O | 16604 | |
| L | 14511 | 8.7% |
| E | 13838 | 8.3% |
| R | 11539 | 6.9% |
| P | 11376 | 6.8% |
| I | 10939 | 6.6% |
| N | 10713 | 6.4% |
| T | 10571 | 6.4% |
| C | 9128 | 5.5% |
| Other values (16) | 39324 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 5493 | |
| r | 4699 | |
| i | 4299 | 8.7% |
| n | 4248 | 8.6% |
| a | 3818 | 7.8% |
| o | 3756 | 7.6% |
| s | 3310 | 6.7% |
| t | 3144 | 6.4% |
| c | 2879 | 5.9% |
| l | 2521 | 5.1% |
| Other values (16) | 11003 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 4775 | |
| . | 3553 | |
| , | 1940 | |
| & | 578 | 4.7% |
| ' | 573 | 4.7% |
| : | 393 | 3.2% |
| ; | 347 | 2.9% |
| # | 6 | < 0.1% |
| " | 4 | < 0.1% |
| % | 1 | < 0.1% |
| Other values (3) | 3 | < 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 27036 | |
| 1 | 7719 | 12.0% |
| 2 | 6090 | 9.5% |
| 3 | 4166 | 6.5% |
| 4 | 3620 | 5.6% |
| 7 | 3353 | 5.2% |
| 9 | 3270 | 5.1% |
| 8 | 3123 | 4.9% |
| 5 | 2942 | 4.6% |
| 6 | 2836 | 4.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 12279 | |
| – | 2 | < 0.1% |
Math Symbol
| Value | Count | Frequency (%) |
| | | 1 | |
| + | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 34300 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 594 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 593 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 215331 | |
| Common | 124099 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 17618 | 8.2% |
| O | 16604 | 7.7% |
| L | 14511 | 6.7% |
| E | 13838 | 6.4% |
| R | 11539 | 5.4% |
| P | 11376 | 5.3% |
| I | 10939 | 5.1% |
| N | 10713 | 5.0% |
| T | 10571 | 4.9% |
| C | 9128 | 4.2% |
| Other values (42) | 88494 |
Common
| Value | Count | Frequency (%) |
| 34300 | ||
| 0 | 27036 | |
| - | 12279 | 9.9% |
| 1 | 7719 | 6.2% |
| 2 | 6090 | 4.9% |
| / | 4775 | 3.8% |
| 3 | 4166 | 3.4% |
| 4 | 3620 | 2.9% |
| . | 3553 | 2.9% |
| 7 | 3353 | 2.7% |
| Other values (21) | 17208 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 339428 | |
| Punctuation | 2 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 34300 | 10.1% | |
| 0 | 27036 | 8.0% |
| S | 17618 | 5.2% |
| O | 16604 | 4.9% |
| L | 14511 | 4.3% |
| E | 13838 | 4.1% |
| - | 12279 | 3.6% |
| R | 11539 | 3.4% |
| P | 11376 | 3.4% |
| I | 10939 | 3.2% |
| Other values (72) | 169388 |
Punctuation
| Value | Count | Frequency (%) |
| – | 2 |
Dimension Set ID
Real number (ℝ)
ZEROS 
| Distinct | 37 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3637.6783 |
| Minimum | 0 |
|---|---|
| Maximum | 86069 |
| Zeros | 2691 |
| Zeros (%) | 34.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 61.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 3449 |
| Q3 | 4379 |
| 95-th percentile | 6342 |
| Maximum | 86069 |
| Range | 86069 |
| Interquartile range (IQR) | 4379 |
Descriptive statistics
| Standard deviation | 5509.0804 |
|---|---|
| Coefficient of variation (CV) | 1.5144496 |
| Kurtosis | 20.138097 |
| Mean | 3637.6783 |
| Median Absolute Deviation (MAD) | 2028 |
| Skewness | 3.8611153 |
| Sum | 28784948 |
| Variance | 30349967 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2691 | |
| 3449 | 1837 | |
| 4379 | 735 | 9.3% |
| 5477 | 416 | 5.3% |
| 5097 | 362 | 4.6% |
| 871 | 278 | 3.5% |
| 3533 | 269 | 3.4% |
| 26977 | 188 | 2.4% |
| 5476 | 182 | 2.3% |
| 3539 | 174 | 2.2% |
| Other values (27) | 781 | 9.9% |
| Value | Count | Frequency (%) |
| 0 | 2691 | |
| 680 | 29 | 0.4% |
| 871 | 278 | 3.5% |
| 1127 | 3 | < 0.1% |
| 1481 | 1 | < 0.1% |
| 2031 | 5 | 0.1% |
| 2141 | 43 | 0.5% |
| 3196 | 74 | 0.9% |
| 3402 | 1 | < 0.1% |
| 3449 | 1837 |
| Value | Count | Frequency (%) |
| 86069 | 1 | < 0.1% |
| 43930 | 10 | 0.1% |
| 31312 | 47 | 0.6% |
| 30008 | 11 | 0.1% |
| 29232 | 2 | < 0.1% |
| 26977 | 188 | |
| 24573 | 2 | < 0.1% |
| 22634 | 2 | < 0.1% |
| 18102 | 121 | |
| 10677 | 1 | < 0.1% |
Doc_ No_ Occurrence
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
| 1 | |
|---|---|
| 0 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 7913 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 6973 | |
| 0 | 940 | 11.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 6973 | |
| 0 | 940 | 11.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 6973 | |
| 0 | 940 | 11.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 7913 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 6973 | |
| 0 | 940 | 11.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 7913 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 6973 | |
| 0 | 940 | 11.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7913 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 6973 | |
| 0 | 940 | 11.9% |
Printed
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 7913 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 7913 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 7913 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 7913 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 7913 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 7913 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 7913 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 7913 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7913 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 7913 |
Date PR Received
Date
| Distinct | 1019 |
|---|---|
| Distinct (%) | 12.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
| Minimum | 1753-01-01 00:00:00 |
|---|---|
| Maximum | 2021-07-09 00:00:00 |
PR Monitoring Status
Real number (ℝ)
ZEROS 
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.353848 |
| Minimum | 0 |
|---|---|
| Maximum | 19 |
| Zeros | 126 |
| Zeros (%) | 1.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 61.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 10 |
| median | 10 |
| Q3 | 10 |
| 95-th percentile | 17 |
| Maximum | 19 |
| Range | 19 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.83613 |
|---|---|
| Coefficient of variation (CV) | 0.27392038 |
| Kurtosis | 4.2098315 |
| Mean | 10.353848 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.012981846 |
| Sum | 81930 |
| Variance | 8.0436331 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 5757 | |
| 17 | 765 | 9.7% |
| 11 | 633 | 8.0% |
| 8 | 313 | 4.0% |
| 0 | 126 | 1.6% |
| 3 | 87 | 1.1% |
| 4 | 80 | 1.0% |
| 2 | 61 | 0.8% |
| 14 | 44 | 0.6% |
| 9 | 23 | 0.3% |
| Other values (4) | 24 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 126 | 1.6% |
| 2 | 61 | 0.8% |
| 3 | 87 | 1.1% |
| 4 | 80 | 1.0% |
| 5 | 1 | < 0.1% |
| 8 | 313 | 4.0% |
| 9 | 23 | 0.3% |
| 10 | 5757 | |
| 11 | 633 | 8.0% |
| 13 | 10 | 0.1% |
| Value | Count | Frequency (%) |
| 19 | 8 | 0.1% |
| 17 | 765 | 9.7% |
| 15 | 5 | 0.1% |
| 14 | 44 | 0.6% |
| 13 | 10 | 0.1% |
| 11 | 633 | 8.0% |
| 10 | 5757 | |
| 9 | 23 | 0.3% |
| 8 | 313 | 4.0% |
| 5 | 1 | < 0.1% |
Purchaser Code
Categorical
MISSING 
| Distinct | 16 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 903 |
| Missing (%) | 11.4% |
| Memory size | 61.9 KiB |
| JCC | |
|---|---|
| ABM | |
| AFR | |
| RSA | |
| LTL | |
| Other values (11) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 21030 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | HSM |
|---|---|
| 2nd row | HSM |
| 3rd row | HSM |
| 4th row | HSM |
| 5th row | HSM |
Common Values
| Value | Count | Frequency (%) |
| JCC | 2783 | |
| ABM | 815 | 10.3% |
| AFR | 775 | 9.8% |
| RSA | 622 | 7.9% |
| LTL | 534 | 6.7% |
| PBB | 443 | 5.6% |
| MMM | 337 | 4.3% |
| JUB | 262 | 3.3% |
| HSM | 124 | 1.6% |
| IGM | 117 | 1.5% |
| Other values (6) | 198 | 2.5% |
| (Missing) | 903 | 11.4% |
Length
| Value | Count | Frequency (%) |
| jcc | 2783 | |
| abm | 815 | 11.6% |
| afr | 775 | 11.1% |
| rsa | 622 | 8.9% |
| ltl | 534 | 7.6% |
| pbb | 443 | 6.3% |
| mmm | 337 | 4.8% |
| jub | 262 | 3.7% |
| hsm | 124 | 1.8% |
| igm | 117 | 1.7% |
| Other values (6) | 198 | 2.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 5586 | |
| J | 3080 | |
| A | 2308 | |
| M | 2290 | |
| B | 2054 | 9.8% |
| R | 1397 | 6.6% |
| L | 1068 | 5.1% |
| F | 775 | 3.7% |
| S | 763 | 3.6% |
| T | 539 | 2.6% |
| Other values (8) | 1170 | 5.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 21030 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 5586 | |
| J | 3080 | |
| A | 2308 | |
| M | 2290 | |
| B | 2054 | 9.8% |
| R | 1397 | 6.6% |
| L | 1068 | 5.1% |
| F | 775 | 3.7% |
| S | 763 | 3.6% |
| T | 539 | 2.6% |
| Other values (8) | 1170 | 5.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 21030 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 5586 | |
| J | 3080 | |
| A | 2308 | |
| M | 2290 | |
| B | 2054 | 9.8% |
| R | 1397 | 6.6% |
| L | 1068 | 5.1% |
| F | 775 | 3.7% |
| S | 763 | 3.6% |
| T | 539 | 2.6% |
| Other values (8) | 1170 | 5.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 21030 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 5586 | |
| J | 3080 | |
| A | 2308 | |
| M | 2290 | |
| B | 2054 | 9.8% |
| R | 1397 | 6.6% |
| L | 1068 | 5.1% |
| F | 775 | 3.7% |
| S | 763 | 3.6% |
| T | 539 | 2.6% |
| Other values (8) | 1170 | 5.6% |
Location Code
Categorical
IMBALANCE  MISSING 
| Distinct | 2 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 7858 |
| Missing (%) | 99.3% |
| Memory size | 61.9 KiB |
| HEAD OFC | |
|---|---|
| CALACA |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 7.7818182 |
| Min length | 6 |
Characters and Unicode
| Total characters | 428 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | HEAD OFC |
|---|---|
| 2nd row | HEAD OFC |
| 3rd row | HEAD OFC |
| 4th row | HEAD OFC |
| 5th row | HEAD OFC |
Common Values
| Value | Count | Frequency (%) |
| HEAD OFC | 49 | 0.6% |
| CALACA | 6 | 0.1% |
| (Missing) | 7858 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| head | 49 | |
| ofc | 49 | |
| calaca | 6 | 5.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 67 | |
| C | 61 | |
| H | 49 | |
| E | 49 | |
| D | 49 | |
| 49 | ||
| O | 49 | |
| F | 49 | |
| L | 6 | 1.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 379 | |
| Space Separator | 49 | 11.4% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 67 | |
| C | 61 | |
| H | 49 | |
| E | 49 | |
| D | 49 | |
| O | 49 | |
| F | 49 | |
| L | 6 | 1.6% |
Space Separator
| Value | Count | Frequency (%) |
| 49 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 379 | |
| Common | 49 | 11.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 67 | |
| C | 61 | |
| H | 49 | |
| E | 49 | |
| D | 49 | |
| O | 49 | |
| F | 49 | |
| L | 6 | 1.6% |
Common
| Value | Count | Frequency (%) |
| 49 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 428 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 67 | |
| C | 61 | |
| H | 49 | |
| E | 49 | |
| D | 49 | |
| 49 | ||
| O | 49 | |
| F | 49 | |
| L | 6 | 1.4% |
TE_transDate
Date
| Distinct | 683 |
|---|---|
| Distinct (%) | 8.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
| Minimum | 1753-01-01 00:00:00 |
|---|---|
| Maximum | 2021-07-12 00:00:00 |
TE_recDate
Date
| Distinct | 564 |
|---|---|
| Distinct (%) | 7.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
| Minimum | 1753-01-01 00:00:00 |
|---|---|
| Maximum | 2021-07-12 00:00:00 |
Equipment No_
Text
MISSING 
| Distinct | 130 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 578 |
| Missing (%) | 7.3% |
| Memory size | 61.9 KiB |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 2.6110429 |
| Min length | 2 |
Characters and Unicode
| Total characters | 19152 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 21 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | ZZZ |
|---|---|
| 2nd row | ZZZ |
| 3rd row | ZZZ |
| 4th row | ZZZ |
| 5th row | ZZZ |
| Value | Count | Frequency (%) |
| zzz | 3475 | |
| bl | 390 | 5.3% |
| ch | 249 | 3.4% |
| che | 244 | 3.3% |
| tu | 206 | 2.8% |
| toi | 170 | 2.3% |
| cw | 152 | 2.1% |
| whs | 146 | 2.0% |
| fc | 131 | 1.8% |
| ah | 112 | 1.5% |
| Other values (117) | 2082 |
Most occurring characters
| Value | Count | Frequency (%) |
| Z | 10425 | |
| C | 1286 | 6.7% |
| H | 867 | 4.5% |
| B | 705 | 3.7% |
| L | 662 | 3.5% |
| E | 616 | 3.2% |
| W | 573 | 3.0% |
| T | 529 | 2.8% |
| F | 504 | 2.6% |
| A | 476 | 2.5% |
| Other values (18) | 2509 | 13.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 18965 | |
| Decimal Number | 165 | 0.9% |
| Space Separator | 22 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| Z | 10425 | |
| C | 1286 | 6.8% |
| H | 867 | 4.6% |
| B | 705 | 3.7% |
| L | 662 | 3.5% |
| E | 616 | 3.2% |
| W | 573 | 3.0% |
| T | 529 | 2.8% |
| F | 504 | 2.7% |
| A | 476 | 2.5% |
| Other values (13) | 2322 | 12.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 133 | |
| 3 | 14 | 8.5% |
| 4 | 10 | 6.1% |
| 2 | 8 | 4.8% |
Space Separator
| Value | Count | Frequency (%) |
| 22 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 18965 | |
| Common | 187 | 1.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| Z | 10425 | |
| C | 1286 | 6.8% |
| H | 867 | 4.6% |
| B | 705 | 3.7% |
| L | 662 | 3.5% |
| E | 616 | 3.2% |
| W | 573 | 3.0% |
| T | 529 | 2.8% |
| F | 504 | 2.7% |
| A | 476 | 2.5% |
| Other values (13) | 2322 | 12.2% |
Common
| Value | Count | Frequency (%) |
| 1 | 133 | |
| 22 | 11.8% | |
| 3 | 14 | 7.5% |
| 4 | 10 | 5.3% |
| 2 | 8 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 19152 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| Z | 10425 | |
| C | 1286 | 6.7% |
| H | 867 | 4.5% |
| B | 705 | 3.7% |
| L | 662 | 3.5% |
| E | 616 | 3.2% |
| W | 573 | 3.0% |
| T | 529 | 2.8% |
| F | 504 | 2.6% |
| A | 476 | 2.5% |
| Other values (18) | 2509 | 13.1% |
Priority
Real number (ℝ)
ZEROS 
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.0520662 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 440 |
| Zeros (%) | 5.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 61.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 4 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.1584824 |
|---|---|
| Coefficient of variation (CV) | 0.37957316 |
| Kurtosis | 0.78912014 |
| Mean | 3.0520662 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -1.2582007 |
| Sum | 24151 |
| Variance | 1.3420815 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 3383 | |
| 3 | 2944 | |
| 1 | 664 | 8.4% |
| 0 | 440 | 5.6% |
| 2 | 429 | 5.4% |
| 5 | 53 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 440 | 5.6% |
| 1 | 664 | 8.4% |
| 2 | 429 | 5.4% |
| 3 | 2944 | |
| 4 | 3383 | |
| 5 | 53 | 0.7% |
| Value | Count | Frequency (%) |
| 5 | 53 | 0.7% |
| 4 | 3383 | |
| 3 | 2944 | |
| 2 | 429 | 5.4% |
| 1 | 664 | 8.4% |
| 0 | 440 | 5.6% |
Reason for Cancellation
Categorical
MISSING 
| Distinct | 10 |
|---|---|
| Distinct (%) | 27.0% |
| Missing | 7876 |
| Missing (%) | 99.5% |
| Memory size | 61.9 KiB |
| Email: FW: MECHANICAL PR CLEAN UP 04//24/2019 | |
|---|---|
| AS PER BQSANPEDRO / EMAIL SUBJECT: "FW: Electrical PR for Clean Up" DATED 03/06/2019 | |
| EMAIL: FW: List of Items from ESD 04/26/2019 | 2 |
| Email: FW: MECHANICAL PR CLEAN UP 04//24/2019 RE-PR SMPPR00742 | 1 |
| Email: FW: MECHANICAL PR CLEAN UP 04//24/2019 RE-PR SMPPR00743 | 1 |
| Other values (5) |
Length
| Max length | 84 |
|---|---|
| Median length | 45 |
| Mean length | 49.189189 |
| Min length | 9 |
Characters and Unicode
| Total characters | 1820 |
|---|---|
| Distinct characters | 51 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | 18.9% |
Sample
| 1st row | AS PER BQSANPEDRO / EMAIL SUBJECT: "FW: Electrical PR for Clean Up" DATED 03/06/2019 |
|---|---|
| 2nd row | AS PER BQSANPEDRO / EMAIL SUBJECT: "FW: Electrical PR for Clean Up" DATED 03/06/2019 |
| 3rd row | AS PER BQSANPEDRO / EMAIL SUBJECT: "FW: Electrical PR for Clean Up" DATED 03/06/2019 |
| 4th row | AS PER BQSANPEDRO / EMAIL SUBJECT: "FW: Electrical PR for Clean Up" DATED 03/06/2019 |
| 5th row | EMAIL: FW: List of Items from ESD 04/26/2019 |
Common Values
| Value | Count | Frequency (%) |
| Email: FW: MECHANICAL PR CLEAN UP 04//24/2019 | 24 | 0.3% |
| AS PER BQSANPEDRO / EMAIL SUBJECT: "FW: Electrical PR for Clean Up" DATED 03/06/2019 | 4 | 0.1% |
| EMAIL: FW: List of Items from ESD 04/26/2019 | 2 | < 0.1% |
| Email: FW: MECHANICAL PR CLEAN UP 04//24/2019 RE-PR SMPPR00742 | 1 | < 0.1% |
| Email: FW: MECHANICAL PR CLEAN UP 04//24/2019 RE-PR SMPPR00743 | 1 | < 0.1% |
| Email: FW: MECHANICAL PR CLEAN UP 04//24/2019 RE-PR SMPPR00744 | 1 | < 0.1% |
| Email: FW: MECHANICAL PR CLEAN UP 04//24/2019 RE-PR SMPPR00741 | 1 | < 0.1% |
| Cancelled as per Amado warehouse | 1 | < 0.1% |
| Cancelled. Refer SMPPR00419 | 1 | < 0.1% |
| Cancelled | 1 | < 0.1% |
| (Missing) | 7876 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 34 | ||
| fw | 34 | |
| pr | 32 | |
| clean | 32 | |
| up | 32 | |
| mechanical | 28 | |
| 04//24/2019 | 28 | |
| as | 5 | 1.8% |
| per | 5 | 1.8% |
| for | 4 | 1.4% |
| Other values (22) | 51 |
Most occurring characters
| Value | Count | Frequency (%) |
| 248 | 13.6% | |
| E | 116 | 6.4% |
| A | 103 | 5.7% |
| / | 100 | 5.5% |
| C | 95 | 5.2% |
| 0 | 82 | 4.5% |
| P | 82 | 4.5% |
| : | 68 | 3.7% |
| 2 | 65 | 3.6% |
| 4 | 64 | 3.5% |
| Other values (41) | 797 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 842 | |
| Decimal Number | 297 | 16.3% |
| Lowercase Letter | 252 | 13.8% |
| Space Separator | 248 | 13.6% |
| Other Punctuation | 177 | 9.7% |
| Dash Punctuation | 4 | 0.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 116 | |
| A | 103 | |
| C | 95 | |
| P | 82 | |
| L | 64 | |
| N | 60 | 7.1% |
| R | 54 | 6.4% |
| M | 39 | 4.6% |
| I | 36 | 4.3% |
| U | 36 | 4.3% |
| Other values (10) | 157 |
Lowercase Letter
| Value | Count | Frequency (%) |
| l | 46 | |
| a | 42 | |
| i | 34 | |
| m | 33 | |
| e | 21 | |
| r | 13 | 5.2% |
| c | 11 | 4.4% |
| o | 10 | 4.0% |
| f | 9 | 3.6% |
| t | 8 | 3.2% |
| Other values (7) | 25 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 82 | |
| 2 | 65 | |
| 4 | 64 | |
| 1 | 36 | |
| 9 | 35 | |
| 6 | 6 | 2.0% |
| 3 | 5 | 1.7% |
| 7 | 4 | 1.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 100 | |
| : | 68 | |
| " | 8 | 4.5% |
| . | 1 | 0.6% |
Space Separator
| Value | Count | Frequency (%) |
| 248 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 4 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1094 | |
| Common | 726 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 116 | 10.6% |
| A | 103 | 9.4% |
| C | 95 | 8.7% |
| P | 82 | 7.5% |
| L | 64 | 5.9% |
| N | 60 | 5.5% |
| R | 54 | 4.9% |
| l | 46 | 4.2% |
| a | 42 | 3.8% |
| M | 39 | 3.6% |
| Other values (27) | 393 |
Common
| Value | Count | Frequency (%) |
| 248 | ||
| / | 100 | |
| 0 | 82 | 11.3% |
| : | 68 | 9.4% |
| 2 | 65 | 9.0% |
| 4 | 64 | 8.8% |
| 1 | 36 | 5.0% |
| 9 | 35 | 4.8% |
| " | 8 | 1.1% |
| 6 | 6 | 0.8% |
| Other values (4) | 14 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1820 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 248 | 13.6% | |
| E | 116 | 6.4% |
| A | 103 | 5.7% |
| / | 100 | 5.5% |
| C | 95 | 5.2% |
| 0 | 82 | 4.5% |
| P | 82 | 4.5% |
| : | 68 | 3.7% |
| 2 | 65 | 3.6% |
| 4 | 64 | 3.5% |
| Other values (41) | 797 |
User ID
Text
MISSING 
| Distinct | 80 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 2559 |
| Missing (%) | 32.3% |
| Memory size | 61.9 KiB |
Length
| Max length | 22 |
|---|---|
| Median length | 21 |
| Mean length | 18.36328 |
| Min length | 15 |
Characters and Unicode
| Total characters | 98317 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | SEMCALACA\EDVELASCO |
|---|---|
| 2nd row | SEMCALACA\EDVELASCO |
| 3rd row | SEMCALACA\EDVELASCO |
| 4th row | SEMCALACA\EDVELASCO |
| 5th row | SEMCALACA\EDVELASCO |
| Value | Count | Frequency (%) |
| semcalaca\mjespera | 1256 | |
| semcalaca\jbescalona | 377 | 7.0% |
| semcalaca\edvelasco | 310 | 5.8% |
| semcalaca\agguevarra | 269 | 5.0% |
| semcalaca\rgviolante | 232 | 4.3% |
| semcalaca\hnmayor | 212 | 4.0% |
| semcalaca\mfnadal | 196 | 3.7% |
| semcalaca\rvendaya | 156 | 2.9% |
| semcalaca\mmbuno | 154 | 2.9% |
| semcalaca\gamatira | 143 | 2.7% |
| Other values (70) | 2049 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 23283 | |
| C | 12159 | |
| E | 9849 | |
| M | 8400 | 8.5% |
| S | 7839 | 8.0% |
| L | 7822 | 8.0% |
| \ | 5354 | 5.4% |
| R | 3594 | 3.7% |
| N | 3136 | 3.2% |
| O | 3037 | 3.1% |
| Other values (14) | 13844 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 92963 | |
| Other Punctuation | 5354 | 5.4% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 23283 | |
| C | 12159 | |
| E | 9849 | |
| M | 8400 | 9.0% |
| S | 7839 | 8.4% |
| L | 7822 | 8.4% |
| R | 3594 | 3.9% |
| N | 3136 | 3.4% |
| O | 3037 | 3.3% |
| J | 2082 | 2.2% |
| Other values (13) | 11762 |
Other Punctuation
| Value | Count | Frequency (%) |
| \ | 5354 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 92963 | |
| Common | 5354 | 5.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 23283 | |
| C | 12159 | |
| E | 9849 | |
| M | 8400 | 9.0% |
| S | 7839 | 8.4% |
| L | 7822 | 8.4% |
| R | 3594 | 3.9% |
| N | 3136 | 3.4% |
| O | 3037 | 3.3% |
| J | 2082 | 2.2% |
| Other values (13) | 11762 |
Common
| Value | Count | Frequency (%) |
| \ | 5354 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 98317 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 23283 | |
| C | 12159 | |
| E | 9849 | |
| M | 8400 | 8.5% |
| S | 7839 | 8.0% |
| L | 7822 | 8.0% |
| \ | 5354 | 5.4% |
| R | 3594 | 3.7% |
| N | 3136 | 3.2% |
| O | 3037 | 3.1% |
| Other values (14) | 13844 |
Plant No_
Categorical
IMBALANCE 
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
| 3 | |
|---|---|
| 0 | 537 |
| 1 | 455 |
| 2 | 414 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 7913 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 3 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 3 | 6507 | |
| 0 | 537 | 6.8% |
| 1 | 455 | 5.8% |
| 2 | 414 | 5.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 3 | 6507 | |
| 0 | 537 | 6.8% |
| 1 | 455 | 5.8% |
| 2 | 414 | 5.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 6507 | |
| 0 | 537 | 6.8% |
| 1 | 455 | 5.8% |
| 2 | 414 | 5.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 7913 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 3 | 6507 | |
| 0 | 537 | 6.8% |
| 1 | 455 | 5.8% |
| 2 | 414 | 5.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 7913 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 3 | 6507 | |
| 0 | 537 | 6.8% |
| 1 | 455 | 5.8% |
| 2 | 414 | 5.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7913 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 3 | 6507 | |
| 0 | 537 | 6.8% |
| 1 | 455 | 5.8% |
| 2 | 414 | 5.2% |
MP Work Order No_
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 7913 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 61.9 KiB |
MISSING 
| Distinct | 940 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 6973 |
| Missing (%) | 88.1% |
| Memory size | 61.9 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 9400 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 940 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | SMPR006229 |
|---|---|
| 2nd row | SMPR006237 |
| 3rd row | SMPR006247 |
| 4th row | SMPR006254 |
| 5th row | SMPR006255 |
| Value | Count | Frequency (%) |
| smpr013759 | 1 | 0.1% |
| smpr006355 | 1 | 0.1% |
| smpr006638 | 1 | 0.1% |
| smpr006237 | 1 | 0.1% |
| smpr006247 | 1 | 0.1% |
| smpr006254 | 1 | 0.1% |
| smpr006255 | 1 | 0.1% |
| smpr006256 | 1 | 0.1% |
| smpr006258 | 1 | 0.1% |
| smpr006259 | 1 | 0.1% |
| Other values (930) | 930 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1607 | |
| 1 | 1011 | |
| S | 940 | |
| M | 940 | |
| P | 940 | |
| R | 940 | |
| 9 | 421 | 4.5% |
| 6 | 416 | 4.4% |
| 4 | 412 | 4.4% |
| 5 | 371 | 3.9% |
| Other values (4) | 1402 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5640 | |
| Uppercase Letter | 3760 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1607 | |
| 1 | 1011 | |
| 9 | 421 | 7.5% |
| 6 | 416 | 7.4% |
| 4 | 412 | 7.3% |
| 5 | 371 | 6.6% |
| 8 | 365 | 6.5% |
| 7 | 351 | 6.2% |
| 2 | 349 | 6.2% |
| 3 | 337 | 6.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 940 | |
| M | 940 | |
| P | 940 | |
| R | 940 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5640 | |
| Latin | 3760 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1607 | |
| 1 | 1011 | |
| 9 | 421 | 7.5% |
| 6 | 416 | 7.4% |
| 4 | 412 | 7.3% |
| 5 | 371 | 6.6% |
| 8 | 365 | 6.5% |
| 7 | 351 | 6.2% |
| 2 | 349 | 6.2% |
| 3 | 337 | 6.0% |
Latin
| Value | Count | Frequency (%) |
| S | 940 | |
| M | 940 | |
| P | 940 | |
| R | 940 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 9400 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1607 | |
| 1 | 1011 | |
| S | 940 | |
| M | 940 | |
| P | 940 | |
| R | 940 | |
| 9 | 421 | 4.5% |
| 6 | 416 | 4.4% |
| 4 | 412 | 4.4% |
| 5 | 371 | 3.9% |
| Other values (4) | 1402 |
PR Item Category
Categorical
IMBALANCE 
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
| 0 | |
|---|---|
| 1 | 20 |
| 3 | 12 |
| 4 | 2 |
| 2 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 7913 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 7878 | |
| 1 | 20 | 0.3% |
| 3 | 12 | 0.2% |
| 4 | 2 | < 0.1% |
| 2 | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 7878 | |
| 1 | 20 | 0.3% |
| 3 | 12 | 0.2% |
| 4 | 2 | < 0.1% |
| 2 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 7878 | |
| 1 | 20 | 0.3% |
| 3 | 12 | 0.2% |
| 4 | 2 | < 0.1% |
| 2 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 7913 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 7878 | |
| 1 | 20 | 0.3% |
| 3 | 12 | 0.2% |
| 4 | 2 | < 0.1% |
| 2 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 7913 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 7878 | |
| 1 | 20 | 0.3% |
| 3 | 12 | 0.2% |
| 4 | 2 | < 0.1% |
| 2 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7913 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 7878 | |
| 1 | 20 | 0.3% |
| 3 | 12 | 0.2% |
| 4 | 2 | < 0.1% |
| 2 | 1 | < 0.1% |
Role Center Status
Real number (ℝ)
ZEROS 
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.1301656 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 3864 |
| Zeros (%) | 48.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 61.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.1237001 |
|---|---|
| Coefficient of variation (CV) | 0.99696483 |
| Kurtosis | -1.8814226 |
| Mean | 2.1301656 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.057998027 |
| Sum | 16856 |
| Variance | 4.5101023 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3864 | |
| 4 | 2950 | |
| 5 | 950 | 12.0% |
| 2 | 137 | 1.7% |
| 3 | 10 | 0.1% |
| 1 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 3864 | |
| 1 | 2 | < 0.1% |
| 2 | 137 | 1.7% |
| 3 | 10 | 0.1% |
| 4 | 2950 | |
| 5 | 950 | 12.0% |
| Value | Count | Frequency (%) |
| 5 | 950 | 12.0% |
| 4 | 2950 | |
| 3 | 10 | 0.1% |
| 2 | 137 | 1.7% |
| 1 | 2 | < 0.1% |
| 0 | 3864 |
No_ Series
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 7913 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 61.9 KiB |
PR Acceptance Date
Categorical
CONSTANT 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
| -53688 |
|---|
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 47478 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | -53688 |
|---|---|
| 2nd row | -53688 |
| 3rd row | -53688 |
| 4th row | -53688 |
| 5th row | -53688 |
Common Values
| Value | Count | Frequency (%) |
| -53688 | 7913 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 53688 | 7913 |
Most occurring characters
| Value | Count | Frequency (%) |
| 8 | 15826 | |
| - | 7913 | |
| 5 | 7913 | |
| 3 | 7913 | |
| 6 | 7913 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 39565 | |
| Dash Punctuation | 7913 | 16.7% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 8 | 15826 | |
| 5 | 7913 | |
| 3 | 7913 | |
| 6 | 7913 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 7913 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 47478 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 8 | 15826 | |
| - | 7913 | |
| 5 | 7913 | |
| 3 | 7913 | |
| 6 | 7913 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 47478 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 8 | 15826 | |
| - | 7913 | |
| 5 | 7913 | |
| 3 | 7913 | |
| 6 | 7913 |
PR Approving Status
Real number (ℝ)
ZEROS 
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.15531404 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 7722 |
| Zeros (%) | 97.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 61.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.0641767 |
|---|---|
| Coefficient of variation (CV) | 6.8517741 |
| Kurtosis | 48.202724 |
| Mean | 0.15531404 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.0198554 |
| Sum | 1229 |
| Variance | 1.1324721 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 7722 | |
| 8 | 129 | 1.6% |
| 1 | 20 | 0.3% |
| 4 | 14 | 0.2% |
| 3 | 9 | 0.1% |
| 2 | 6 | 0.1% |
| 6 | 6 | 0.1% |
| 5 | 4 | 0.1% |
| 9 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 7722 | |
| 1 | 20 | 0.3% |
| 2 | 6 | 0.1% |
| 3 | 9 | 0.1% |
| 4 | 14 | 0.2% |
| 5 | 4 | 0.1% |
| 6 | 6 | 0.1% |
| 7 | 1 | < 0.1% |
| 8 | 129 | 1.6% |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 10 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| 8 | 129 | |
| 7 | 1 | < 0.1% |
| 6 | 6 | 0.1% |
| 5 | 4 | 0.1% |
| 4 | 14 | 0.2% |
| 3 | 9 | 0.1% |
| 2 | 6 | 0.1% |
| 1 | 20 | 0.3% |
PR Type
Categorical
IMBALANCE 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 61.9 KiB |
| 0 | |
|---|---|
| 2 | 84 |
| 1 | 64 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 7913 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 7765 | |
| 2 | 84 | 1.1% |
| 1 | 64 | 0.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 7765 | |
| 2 | 84 | 1.1% |
| 1 | 64 | 0.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 7765 | |
| 2 | 84 | 1.1% |
| 1 | 64 | 0.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 7913 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 7765 | |
| 2 | 84 | 1.1% |
| 1 | 64 | 0.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 7913 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 7765 | |
| 2 | 84 | 1.1% |
| 1 | 64 | 0.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 7913 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 7765 | |
| 2 | 84 | 1.1% |
| 1 | 64 | 0.8% |
| timestamp | No_ | PR Date | Printing Date | Department | Intended For | Phase of Work | Reference | Work Description | Date Needed | Batch | Template | External PR No_ | Status | ReOpened | Release Date | Remarks | Dimension Set ID | Doc_ No_ Occurrence | Printed | Date PR Received | PR Monitoring Status | Purchaser Code | Location Code | TE_transDate | TE_recDate | Equipment No_ | Priority | Reason for Cancellation | User ID | Plant No_ | MP Work Order No_ | Reference MP PR No_ | PR Item Category | Role Center Status | No_ Series | PR Acceptance Date | PR Approving Status | PR Type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 000000000FD66B8C | BRPR-00003 | 2014-10-28 | -53688 | 150.0 | 2X150MW POWER PLANT | NaN | BILLING INVOICE | NaN | 2014-10-31 | NaN | REQ. | NaN | 1 | 1 | 2014-10-29 | SLBPO-000028 OCEAN STAR FREIGHT EXPRESS | 0 | 1 | 0 | 2014-10-28 | 10 | HSM | NaN | 1753-01-01 | 1753-01-01 | NaN | 0 | NaN | NaN | 3 | NaN | NaN | 0 | 2 | NaN | -53688 | 0 | 0 |
| 1 | 000000000FD66B8D | BRPR-00004 | 2014-10-28 | -53688 | 150.0 | 2X150MW POWER PLANT | NaN | ATTACHED BROKER SOA | NaN | 1753-01-01 | NaN | REQ. | NaN | 1 | 1 | 2014-10-29 | SLBPO-000002 AMERICAN FREIGHT FORWARDERS, INC. | 0 | 1 | 0 | 2014-10-28 | 10 | HSM | NaN | 1753-01-01 | 1753-01-01 | NaN | 0 | NaN | NaN | 0 | NaN | NaN | 0 | 4 | NaN | -53688 | 0 | 0 |
| 2 | 000000000FD66B8E | BRPR-00005 | 2014-10-28 | -53688 | 150.0 | 2X150MW POWER PLANT | NaN | ATTACHED BROKER SOA | NaN | 1753-01-01 | NaN | REQ. | NaN | 1 | 1 | 2014-10-29 | SLBPO-000003 CARGO PLUS FREIGHT EXPRESS | 0 | 1 | 0 | 2014-10-28 | 10 | HSM | NaN | 1753-01-01 | 1753-01-01 | NaN | 0 | NaN | NaN | 0 | NaN | NaN | 0 | 4 | NaN | -53688 | 0 | 0 |
| 3 | 000000000FD66B8F | BRPR-00006 | 2014-10-28 | -53688 | 150.0 | 2X150MW POWER PLANT | NaN | ATTACHED BILLING STATEMENT | NaN | 1753-01-01 | NaN | REQ. | NaN | 1 | 1 | 2014-10-29 | SLBPO-000020 GCLPI-GATEWAY CONTAINER LINE PHILS. INC. | 0 | 1 | 0 | 2014-10-28 | 10 | HSM | NaN | 1753-01-01 | 1753-01-01 | NaN | 0 | NaN | NaN | 3 | NaN | NaN | 0 | 2 | NaN | -53688 | 0 | 0 |
| 4 | 000000000FD66B90 | BRPR-00007 | 2014-10-28 | -53688 | 150.0 | 2X150MW POWER PLANT | NaN | ATTACHED BROKER'S BILLING | NaN | 1753-01-01 | NaN | REQ. | NaN | 1 | 1 | 2014-10-30 | SLBPO-000019 CARGO PLUS FREIGHT EXPRESS | 0 | 1 | 0 | 2014-10-28 | 10 | HSM | NaN | 1753-01-01 | 1753-01-01 | NaN | 0 | NaN | NaN | 0 | NaN | NaN | 0 | 0 | NaN | -53688 | 0 | 0 |
| 5 | 000000000FD66B91 | BRPR-00008 | 2014-10-28 | -53688 | 150.0 | 2X150MW POWER PLANT | NaN | ATTACHED BROKER'S SOA | NaN | 1753-01-01 | NaN | REQ. | NaN | 1 | 1 | 2014-10-29 | SLBPO-000018 CARGO PLUS FREIGHT EXPRESS | 0 | 1 | 0 | 2014-10-28 | 10 | HSM | NaN | 1753-01-01 | 1753-01-01 | NaN | 0 | NaN | NaN | 3 | NaN | NaN | 0 | 4 | NaN | -53688 | 0 | 0 |
| 6 | 000000000FD66B92 | BRPR-00009 | 2014-10-28 | -53688 | 150.0 | 2X150M POWER PLANT | NaN | ATTACHED BROKER'S SOA | NaN | 1753-01-01 | NaN | REQ. | NaN | 1 | 1 | 2014-10-30 | SLBPO-000017 CARGO PLUS FREIGHT EXPRESS | 0 | 1 | 0 | 2014-10-28 | 10 | HSM | NaN | 1753-01-01 | 1753-01-01 | NaN | 0 | NaN | NaN | 0 | NaN | NaN | 0 | 4 | NaN | -53688 | 0 | 0 |
| 7 | 000000000FD66B93 | BRPR-00010 | 2014-10-29 | -53688 | 150.0 | 2X150MW POWER PLANT | NaN | ATTACHED BROKER'S BILLING INVOICE | NaN | 2014-10-31 | NaN | REQ. | NaN | 1 | 1 | 2014-10-30 | SLBPO-000016 CARGO PLUS FREIGHT EXPRESS | 0 | 1 | 0 | 2014-10-29 | 10 | HSM | NaN | 1753-01-01 | 1753-01-01 | NaN | 0 | NaN | NaN | 3 | NaN | NaN | 0 | 4 | NaN | -53688 | 0 | 0 |
| 8 | 000000000FD66B94 | BRPR-00011 | 2014-10-29 | -53688 | 150.0 | 2X150MW POWER PLANT | NaN | ATTACHED BILLING INVOICE | NaN | 1753-01-01 | NaN | REQ. | NaN | 1 | 1 | 2014-10-29 | SLBPO-000015 CARGO PLUS FREIGHT EXPRESS | 0 | 1 | 0 | 2014-10-29 | 10 | HSM | NaN | 1753-01-01 | 1753-01-01 | NaN | 0 | NaN | NaN | 3 | NaN | NaN | 0 | 4 | NaN | -53688 | 0 | 0 |
| 9 | 000000000FD66B95 | BRPR-00012 | 2014-10-29 | -53688 | 150.0 | 2X150MW POWER PLANT | NaN | ATTACHED BILLING INVOICE | NaN | 1753-01-01 | NaN | REQ. | NaN | 1 | 1 | 2014-10-30 | SLBPO-000014 CARGO PLUS FREIGHT EXPRESS | 0 | 1 | 0 | 2014-10-29 | 10 | HSM | NaN | 1753-01-01 | 1753-01-01 | NaN | 0 | NaN | NaN | 3 | NaN | NaN | 0 | 4 | NaN | -53688 | 0 | 0 |
| timestamp | No_ | PR Date | Printing Date | Department | Intended For | Phase of Work | Reference | Work Description | Date Needed | Batch | Template | External PR No_ | Status | ReOpened | Release Date | Remarks | Dimension Set ID | Doc_ No_ Occurrence | Printed | Date PR Received | PR Monitoring Status | Purchaser Code | Location Code | TE_transDate | TE_recDate | Equipment No_ | Priority | Reason for Cancellation | User ID | Plant No_ | MP Work Order No_ | Reference MP PR No_ | PR Item Category | Role Center Status | No_ Series | PR Acceptance Date | PR Approving Status | PR Type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7903 | 000000000FD689DD | TDCPR-0004 | 2016-02-22 | -53688 | 845.0 | DOCUMENT MANAGEMENT SYSTEM | NaN | NaN | NaN | 2016-04-30 | NaN | REQ. | NaN | 0 | 0 | 1753-01-01 | ANNUAL MAINTENANCE AGREEMENT OF DOCUMENTUM | 0 | 1 | 0 | 2016-02-22 | 17 | JCC | NaN | 1753-01-01 | 1753-01-01 | ZZZ | 4 | NaN | NaN | 3 | NaN | NaN | 0 | 0 | NaN | -53688 | 0 | 0 |
| 7904 | 000000000FD689DE | TDCPR-0005 | 2017-03-14 | -53688 | 845.0 | IMS TEAM | IMS TEAM UNIFORM | NaN | NaN | 2017-04-03 | NaN | REQ. | NaN | 1 | 1 | 2017-03-23 | SLPO-001928 Seine garments corp. | 0 | 1 | 0 | 2017-03-14 | 10 | JCC | NaN | 1753-01-01 | 1753-01-01 | ZZZ | 4 | NaN | SEMCALACA\GALLAM | 3 | NaN | NaN | 0 | 0 | NaN | -53688 | 0 | 0 |
| 7905 | 000000000FD689DF | TDCPR-0006 | 2018-03-08 | -53688 | 845.0 | FOR VARIOUS MEETINGS | NaN | NaN | NaN | 2018-04-02 | NaN | REQ. | NaN | 1 | 1 | 2018-03-13 | SLPO-002918 ANDELAI GENERAL MERCHANDISE, INC. /SLPO-002919 E-PLUS STATIONERY, INC. /SLPO-002920 SQUARE DEAL OFFICE RESOURCES INC. | 5481 | 1 | 0 | 2018-03-13 | 10 | PBB | NaN | 2018-03-22 | 2018-04-04 | ZZZ | 3 | NaN | SEMCALACA\GALLAM | 3 | NaN | NaN | 0 | 0 | NaN | -53688 | 0 | 0 |
| 7906 | 000000000FD689E0 | TDCPR-0007 | 2018-03-09 | -53688 | 845.0 | TO BE USED FOR THE NEW COMPANY | NaN | NaN | NaN | 2018-03-26 | NaN | REQ. | NaN | 1 | 1 | 2018-03-16 | SLPO-003008 TRANSGLOBE INDUSTRIAL | 5481 | 1 | 0 | 2018-03-09 | 10 | PBB | NaN | 2018-04-06 | 2018-04-18 | ZZZ | 3 | NaN | SEMCALACA\GALLAM | 3 | NaN | NaN | 0 | 4 | NaN | -53688 | 0 | 0 |
| 7907 | 000000000FD689E1 | TDCPR-0008 | 2018-03-12 | -53688 | 845.0 | IMS/TDC OFFICE | TRANSFER OF OFFICE | NaN | MODIFICATION OF TDC/IMS OFFICE | 2018-04-02 | NaN | REQ. | NaN | 1 | 1 | 2018-03-15 | AS PER KBSJ | 5481 | 1 | 0 | 2018-03-15 | 11 | IGM | NaN | 1753-01-01 | 1753-01-01 | ZZZ | 4 | NaN | SEMCALACA\GALLAM | 3 | NaN | NaN | 0 | 4 | NaN | -53688 | 0 | 0 |
| 7908 | 000000000FD689E2 | TDCPR-0009 | 2018-05-31 | -53688 | 845.0 | IMS INCENTIVE AWARD | GHG TEAM INCENTIVE | NaN | NaN | 2018-06-15 | NaN | REQ. | NaN | 1 | 1 | 2018-06-16 | SLPO-003228 SEINE GARMENTS CORP. | 5481 | 1 | 0 | 2018-06-16 | 10 | PBB | NaN | 2018-07-25 | 2018-08-02 | ZZZ | 4 | NaN | SEMCALACA\GALLAM | 3 | NaN | NaN | 0 | 0 | NaN | -53688 | 0 | 0 |
| 7909 | 000000000FD689E3 | TDCPR-0010 | 2018-08-07 | -53688 | 845.0 | ANNUAL OPERATIONS PLANNING | PLANNING | NaN | NaN | 2018-08-31 | NaN | REQ. | NaN | 1 | 1 | 2018-08-31 | NEEDED PRIOR TO SCHEDULED PLANNING ON SEPT. 7-8 /SLPO-003295 SEINE GARMENTS CORP. | 5481 | 1 | 0 | 2018-08-14 | 10 | PBB | NaN | 1753-01-01 | 1753-01-01 | ZZZ | 4 | NaN | SEMCALACA\GALLAM | 3 | NaN | NaN | 0 | 4 | NaN | -53688 | 0 | 0 |
| 7910 | 000000000FD689E4 | TDCPR-0011 | 2019-04-10 | -53688 | 845.0 | TECHNICAL DOCUMENTATION (MANUALS) | TECHNICAL DOCUMENTATION DIGITIZATION /MODIFICATION | NaN | DIGITIZATION OF MANUALS | 2019-04-30 | NaN | REQ. | NaN | 0 | 1 | 2019-05-15 | As per Sir RVE cancelled this PR thru email dated 8/27/2020 | 5481 | 1 | 0 | 2019-05-16 | 11 | MMM | NaN | 2019-07-31 | 1753-01-01 | ZZZ | 4 | NaN | SEMCALACA\GALLAM | 3 | NaN | NaN | 0 | 4 | NaN | -53688 | 0 | 0 |
| 7911 | 000000000FD689E5 | TDCPR-0013 | 2020-02-26 | -53688 | 848.0 | DIGITIZATION PROJECT | CENTRALIZATION OF TECHNICAL DOCUMENTS | OTP 2020 / BUDGET CAPEX 2020 | SCANNING AND PHOTOCOPYING OF TECH. DOC. | 2020-03-26 | NaN | REQ. | NaN | 1 | 1 | 2020-03-06 | SLPO-004645 Tricom Dynamics / SLPO-004646 PARAMOUNT | 43930 | 1 | 0 | 2020-03-09 | 10 | AFR | NaN | 2020-06-18 | 2020-06-24 | ZZZ | 4 | NaN | SEMCALACA\JBDELACRUZ | 3 | NaN | NaN | 0 | 5 | NaN | -53688 | 0 | 0 |
| 7912 | 000000000FD689E6 | TDCPR-0014 | 2020-03-02 | -53688 | 848.0 | Asset Management - TDC | Centralization of technical documents | NaN | CAD Servicing of TDC technical drawings | 2020-04-01 | NaN | REQ. | NaN | 1 | 1 | 2020-05-11 | NaN | 43930 | 1 | 0 | 2020-05-21 | 3 | ABM | NaN | 2020-06-23 | 1753-01-01 | ZZZ | 4 | NaN | SEMCALACA\JBDELACRUZ | 3 | NaN | NaN | 0 | 4 | NaN | -53688 | 0 | 0 |